UCSF

Parameters Provided:

name.synonym = 1-Cyclopropyl-7-(4-ethyl-1-piperazinyl)-6-fluoro-1,4-dihydro-4-oxo-3-quinolinecarboxylic acid, 9CI;Bay VP 2674;Baytril;Baytril (TN);CFPQ;Endrofloxicin;Enrofloxacin (usan/inn);Enrofloxacin [usan:ban:inn];Enrofloxacine;Enrofloxacino;Enrofloxacinum;Enroxil;E
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-Cyclopropyl-7-(4-ethyl-1-piperazinyl)-6-fluoro-1,4-dihydro-4-oxo-3-quinolinecarboxylic acid, 9CI;Bay VP 2674;Baytril;Baytril (TN);CFPQ;Endrofloxicin;Enrofloxacin (usan/inn);Enrofloxacin [usan:ban:inn];Enrofloxacine;Enrofloxacino;Enrofloxacinum;Enroxil;E' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-Cyclopropyl-7-%284-ethyl-1-piperazinyl%29-6-fluoro-1%2C4-dihydro-4-oxo-3-quinolinecarboxylic+acid%2C+9CI%3BBay+VP+2674%3BBaytril%3BBaytril+%28TN%29%3BCFPQ%3BEndrofloxicin%3BEnrofloxacin+%28usan%2Finn%29%3BEnrofloxacin+%5Busan%3Aban%3Ainn%5D%3BEnrofloxacine%3BEnrofloxacino%3BEnrofloxacinum%3BEnroxil%3BE&filter.purchasability=all

Embed Link to Results